--
-- PostgreSQL database dump
--

-- Started on 2006-11-01 17:52:55 W. Europe Standard Time

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 1512 (class 1262 OID 16403)
-- Name: DBtry; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE DBtry WITH TEMPLATE = template0 ENCODING = 'UTF8';


ALTER DATABASE DBtry OWNER TO postgres;
commit;
\connect DBtry

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 1513 (class 0 OID 0)
-- Dependencies: 4
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- TOC entry 250 (class 2612 OID 16386)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
--

CREATE PROCEDURAL LANGUAGE plpgsql;


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1184 (class 1259 OID 24613)
-- Dependencies: 4
-- Name: rdgdb; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE rdgdb (
    name character(50),
    surname character(50),
    id serial NOT NULL
);


ALTER TABLE public.rdgdb OWNER TO postgres;

--
-- TOC entry 1185 (class 1259 OID 24615)
-- Dependencies: 4
-- Name: s_rdgdb_id; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE s_rdgdb_id
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.s_rdgdb_id OWNER TO postgres;

--
-- TOC entry 1510 (class 2606 OID 24624)
-- Dependencies: 1184 1184
-- Name: id; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY rdgdb
    ADD CONSTRAINT id PRIMARY KEY (id);


--
-- TOC entry 1514 (class 0 OID 0)
-- Dependencies: 4
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2006-11-01 17:52:55 W. Europe Standard Time

--
-- PostgreSQL database dump complete
--

